package com.car.vo;

import lombok.Data;

/**
 * @Package:com.car.vo
 * @Author:敬乾超 2020/6/28 18:45:17
 */
@Data
public class VoCarConfiged {

    private Long id;
    private String configName;
    private String motorType;
    private String motorBrandName;
    private Long motorModelId;
    private Long packId;
    private String baoModelName;
    private Integer moduleNums;
    private Long kindId;
    private String kindName;
    private Long typeId;
    private String carTypeName;
    /**
     * SELECT
     * 	config.id id,
     * 	config.config_name config_name,
     * 	motor.motor_brand_name motor_brand_name,
     * 	motor.motor_type motor_type,
     * 	motor.motor_model_id motor_model_id,
     * 	pack.id id,
     * 	pack.bao_model_name,
     * 	pack.module_nums,
     * 	kind.id,
     * 	kind.kind_name,
     * 	type.id,
     * type.car_type_name
     * FROM
     * 	tb_car_preconfigured config
     * LEFT JOIN tb_part_motor_model motor ON config.motor_id = motor.motor_model_id
     * LEFT JOIN tb_part_battery_pack pack ON config.battery_pack_id = pack.id
     * #LEFT JOIN tb_part_sim sim ON config.sim_id = sim.id
     * LEFT JOIN tb_part_terminal_type terminal ON config.terminal_id = terminal.id
     * LEFT JOIN tb_car_kind kind ON config.car_kind_id = kind.id
     * LEFT JOIN tb_car_type type ON config.car_type_id = type.id
     */

}
